<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( '../global/initialize.php' );

$query = "SELECT upgrade_id " .
		"FROM upgrades " .
		"ORDER BY name";
$result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
$num = mysql_numrows( $result );
$status = "";
$i = 0;
$done = false;
while ( $i < $num && !$done ) {
	$upgrade_id = mysql_result( $result, $i, "upgrade_id" );
	if( isset( $_POST[ $upgrade_id ] ) ) {
		$query = "SELECT count(*) FROM upgrade_status WHERE ruler_id = " . $_SESSION[ 'ruler_id' ] . " AND achieved = 0";
		$result2 = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
		$total = $row2[ 'count(*)' ];
		if( $total < 0 ) {
			$total = 0;	
		}
		if( $total < getQueueLength() ) {
			$query = "SELECT MAX(level) FROM upgrade_status WHERE ruler_id = " . $_SESSION[ 'ruler_id' ] . " AND upgrade_id = " . $upgrade_id;
			$result2 = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
			$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
			$level = $row2[ 'MAX(level)' ] + 1;
			
			$query = "INSERT INTO upgrade_status ( ruler_id, upgrade_id, rank, level ) VALUES ( " . $_SESSION[ 'ruler_id' ] . ", $upgrade_id, $total, $level )";
			mysql_query( $query ) or die( "Query failed : " . mysql_error() );
			$status = translate( 'Added to queue' );
		}
		else {
			$done = true;
			$status = translate( "Upgrade queue is full." );
		}
	}
	$i ++;
}
if( $status != "" ) $_SESSION[ 'que_upgrade_status' ] = $status;
header( "Location: upgrade.php" );
?>

